Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
MembershipProgramID (FK)(PK) | Token ID for a CustomerRewardProgram instance. | ID_CT_MBRSHP_PRGM | Identity | integer | CustomerMembershipProgram(CO_CT_MBRSHP_PRGM) |
LevelNumber (PK) | A whole number that establishes the relative value of a membership program level. The higher the value, the greater the level and its associated rewards and, where applicable, fees. | IC_LV_NMB | Number | integer | |
LevelCode | A code that identifies a membership level. Membership levels typically offer different kinds of rewards and, where fees are involved charge different fee amounts. Examples of codes include: PLATINUM GOLD SILVER BRONZE | CD_LV | Code | varchar(20) | |
LevelInitialFeeAmount | The initial fee that is charged to join as a member. Only applies if the CustomerMembershipProgram is a paid for program. Examples includ various chains like Costco, Sam's Club, BJ's - all charge a fee based on membership program level. | MO_LV_INT_FE_AMT | Money | decimal(16,5) | |
LevelPeriodicRenewalFeeAmount | The periodic renewal fee for a specific membership level. Some shopping club memberships (e.g. Costco, Sam's, BJs) require an annual fee to renew membership. Some programs (e.g. REI) require only a one time fee to join. | MO_LV_PRDC_RNWL_FE_AMT | Money | decimal(16,5) | |